package com.ruoyi.system.mapper;


import com.ruoyi.system.domain.BusiProjectItem;
import com.ruoyi.system.domain.ProjectAndItem;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BusiProjectItemMapper {
    int deleteByPrimaryKey(String itemId);

    int insert(BusiProjectItem record);

    int insertSelective(BusiProjectItem record);

    BusiProjectItem selectByName(String name);

    BusiProjectItem selectById(String id);

    int updateByPrimaryKeySelective(BusiProjectItem record);

    int updateByPrimaryKey(BusiProjectItem record);

    /**
     * 通过项目id查询对应的子项目
     *
     * @return
     */
    List<BusiProjectItem> findByProjectId(String projectId);

    /**
     * 查询所有
     *
     * @return
     */
    List<BusiProjectItem> show();

    //连表查询所有
    List<ProjectAndItem> showAll();

    //多条件模糊查询
    List<BusiProjectItem> find(@Param("projectName") String projectName,
                               @Param("projectCode") String projectCode,
                               @Param("itemName") String itemName);
}